Forum Replies Created

Viewing 15 posts - 11,296 through 11,310 (of 13,460 total)

  • RE: Idenity column question /issue

    gaps in an identity are normal. they happen when an error occurs and a transaction gets rolled back; although a transaction would not get committed, the incrementing of an identity...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 5:36 pm

    #972238

  • RE: inserting a list into a table that does not allow duplicates

    i think the statement you pasted is missing which column in t1 is null; was that a copy/paste error?

    it looks a little like pseudo code;

    this is how I would do...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 5:32 pm

    #972237

  • RE: inserting a list into a table that does not allow dupes

    duplicate post.(actually triplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 5:26 pm

    #972236

  • RE: inserting a list into a list that does not allow dupes

    duplicate post.(actually triplicate!)

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 5:25 pm

    #972235

  • RE: Primary Key Violation on a unique primary key

    there you go!

    it's always the unexpected values in the data that trip me up too.

    way to go!

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 1:20 pm

    #972215

  • RE: Primary Key Violation on a unique primary key

    you can use this to find the duplicating records, based on your SQL;

    SELECT adv.A_AdvertiserID

    ,'Mobile'

    ,ab.[Telephone2]

    FROM [MSCRM].[dbo].[AccountBase] ab

    JOIN [DIGADV].[dbo].[Advertiser] adv

    ON ab.[Name] COLLATE DATABASE_DEFAULT = adv.A_AdvertiserName COLLATE DATABASE_DEFAULT

    GROUP BY adv.A_AdvertiserID,ab.[Telephone2]

    HAVING COUNT(*) > 1

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 5, 2009 at 10:54 am

    #972183

  • RE: Random String on Record Creation

    sorry about the naming thing...i wrote my comments, then added the code, change the name along the way in there....

    glad it's working for you.

    did you change it to be a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 4, 2009 at 7:25 pm

    #972117

  • RE: Random String on Record Creation

    you'll need to make your code a function.

    once it is a function, say udfRandomString()

    you can create a table and set it's default value to the function.

    you might run into problems...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 4, 2009 at 5:32 pm

    #972112

  • RE: just

    I'm admittedly slow at times, but i just changed the time on my server to 12 hours earlier than the real time..., and compared getdate() to OS time; they are...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 4, 2009 at 10:00 am

    #972070

  • RE: just

    saravanantvr1984 (4/4/2009)

    But, I don't know OS command like how to change the Date time of server machine...

    do u have a IDEA?

    Please send that

    start>>Run cmd ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 4, 2009 at 7:16 am

    #972047

  • RE: Dnt want to use Dynamic Sql

    it's the way the IN function works:

    the IN() function requires an array() of values, NOT a single variable that happens to have commas in it. that's what you have...a single...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 3, 2009 at 7:19 am

    #971528

  • RE: How to queue multiple requests in database

    SLQ server automatically handles queueing via a system of LOCKING at the row,then page,then table levels;

    a great example is multiple people updating a single table.

    there is no need to block...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 3, 2009 at 6:45 am

    #971476

  • RE: Dnt want to use Dynamic Sql

    mithun.gite (4/3/2009)

    yeah thanks for that function actually, we have this function and we are using it also... and we handling such situation thru dynamic sqll......but this question has come when...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 3, 2009 at 6:40 am

    #971469

  • RE: Dnt want to use Dynamic Sql

    you sure THAT function is working?

    it's definition is:

    Returns @Tbl_IDs Table (ID Int)

    but you are passing varchar GUIDS...so i doubt it returns anything valid.

    set @Ids='''fe44fcb1-49c5-4a03-93de-6fadfbb5dbd0'',''FD857BFA-13F9-4051-91B8-6677D2A31C52'''

    won't be right, something like this...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 3, 2009 at 6:33 am

    #971464

  • RE: Dnt want to use Dynamic Sql

    in one way or another, a comma delimited parameter needs to use one of the many SPLIT() functions from the Scripts section on SSC, or use dynamic SQL; there's no...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 3, 2009 at 6:19 am

    #971452

Viewing 15 posts - 11,296 through 11,310 (of 13,460 total)