Viewing 15 posts - 11,311 through 11,325 (of 13,462 total)
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...
April 3, 2009 at 6:33 am
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...
April 3, 2009 at 6:19 am
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...
April 3, 2009 at 6:16 am
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...
April 3, 2009 at 6:15 am
duplicate post.(actually quaduplicate!)
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...
April 3, 2009 at 6:14 am
duplicate post.(actually quaduplicate!)
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...
April 3, 2009 at 6:14 am
duplicate post.(actually quaduplicate!)
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...
April 3, 2009 at 6:14 am
I've seen an app like that, and upon investigation, found out that giving rights to Public was a knee jerk reaction to fix permissions by someone who did not understand...
April 2, 2009 at 8:48 pm
you can use SELECT DISTINCT ....[columns]...FROM YOURTABLE to eliminate duplicates.
if the whole row of data is not unique, then you'll have to use GROUP BY , putting columns you don't...
April 2, 2009 at 3:36 am
edit your new posts so they do not use huge font, and remove the two duplicates...very annoying.
the error message says it all...Google could have saved you hours of waiting.
you are...
April 2, 2009 at 3:13 am
fredsql (4/2/2009)
April 2, 2009 at 3:06 am
drewsx2 (4/1/2009)
Hello,
I have a Table in my DB that is used by multiple other tables. It looks like this:
ID Type User_ID
1...
April 1, 2009 at 8:28 pm
here's an example, assuming you are using row_number() function to decide how many rows:
you might need to fiddle with it,
declare @WhichPage int
Set @WhichPage = 3
SELECT * FROM (
select row_number()...
April 1, 2009 at 11:00 am
GilaMonster (4/1/2009)
Is that table properly normalised? Do all of those columns belong in there?
Gail has identified the root cause of your problem...I've yet to see a table with that many...
April 1, 2009 at 9:49 am
say you want to add 100 new fields to your Table250.
I would simply add a new table, with a foreign key to the original table, and a UNIQUE constraint on...
April 1, 2009 at 9:47 am
Viewing 15 posts - 11,311 through 11,325 (of 13,462 total)