I am stuck with this Query in sql server

Question

0.00/5 (No votes)

See more:

Assume this is my agent code

'DGP 1 01052013'

DGP is string

the last 8 digit is the current date and the in between integer is unique code ,its should be increase for every agent entry

it should be like

DGP 2 01052013
DGP 3 01052013
...
DGP 10 01052013

...
DGP 100 01052013
no spaces between the code.

Solutions..?

Posted 28-Oct-13 19:26pm

King Fisher

Add a Solution

Comments

VICK 29-Oct-13 1:27am

What have you tried and Where You are stuck?? Post your query..

King Fisher 29-Oct-13 1:52am

select right(advisor_code,8)from tbl_advisor_table

select (SUBSTRING (advisor_code,4,100)) from tbl_advisor_table

this is upto ma knowledge

4 solutions

Solution 1

With the help ofTrim function
check the link
http://consultingblogs.emc.com/jamespipe/archive/2007/08/14/SQL_3A00_-A-49-character-long-_2700_empty_2700_-field_3F00_.aspx[^]

http://blog.sqlauthority.com/2013/01/23/sql-server-trim-function-to-remove-leading-and-trailing-spaces-of-string-sql-in-sixty-seconds-040-video/[^]

Posted 28-Oct-13 19:38pm

indrajeet jadhav

Updated 28-Oct-13 20:13pm

v2

Solution 4

Please follow below link for your problem ..

Get Max Identity in a Table[^]

http://stackoverflow.com/questions/5501142/get-max-value-for-identity-column-without-a-table-scan[^]

Thanks
AARIF SHAIKH

Posted 6-Apr-15 20:15pm

aarif moh shaikh

Comments

King Fisher 7-Apr-15 2:38am

I got solved this Question 1.5 yr ago. ;)

CHill60 7-Apr-15 3:27am

Not only is this an old question (as the OP has pointed out to you) but your solution has nothing to do with the actual problem!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Accepted Answer · 2013-10-28T19:44:00

Solution 2

See this link : Custom Auto-Generated Sequences with SQL Server[^]

Regards...

Posted 28-Oct-13 19:44pm

Thanks7872

Comments

King Fisher 29-Oct-13 2:00am

i wanna increase the middle value

Thanks7872 29-Oct-13 2:08am

Go through that Article,learn how to do that an implement it.

King Fisher 29-Oct-13 2:39am

yes i do,

VeeraAnnapureddy · Accepted Answer · 2013-10-28T20:21:00

Solution 3

SQL

create table  ad
(
Id int identity(1,1),
Pid as case  len(Id) when 1 then 'DGP'+' '+convert(varchar,ID)+' '+'01052013'
when 2 then 'DGP'+convert(varchar,ID)+'01052013'
else 'DGP'+convert(varchar,ID)
end
)

INSERT INTO ad DEFAULT VALUES

Posted 28-Oct-13 20:21pm

VeeraAnnapureddy

Comments

King Fisher 29-Oct-13 2:30am

it s nice .thank u

King Fisher 29-Oct-13 2:40am

the last string should be the current date..

King Fisher 7-Dec-13 7:52am

i hope u can ..
http://www.codeproject.com/Questions/693539/left-join-in-multiple-tables