Topics
Started by
Posts
Last post
So I stumbled on this command: SELECT * FROM :: fn_trace_getinfo(default) Yet if I remove that :: …
5 replies
Hi Experts, When i tried to execute the below query in biztalk I am getting locks .. Please help /*…
3 replies
T_SQL is wrong, some help is much appreciated. IF EXISTS (SELECT DATEPART(hh, scheduledtime) FROM…
4 replies
I am trying to figure out what I am doing wrong when trying to create a grouping for each pair of "…
6 replies
Hi, In my sproc#1 i am calling my TVP(table valued parameter) with a bunch of otehr param. towards…
1 replies
This is my solution declare @TableVar table ( Key1 int NOT NULL , VAL1 int NOT NULL , VAL2 int N…
15 replies
I am new to TSQL. Have two tables with rows item_guid . I have to join these two tables and check f…
1 replies
Hey forumites, Below is a ddl for a problem i am having. I want to sum up the total for each good b…
7 replies
Hi Everyone, Below is a query that is running extremely slow in 2008. By slow I mean 15+ minutes…
4 replies
I am trying to join three tables. The third one is to a linked server. I havn't done this before b…
2 replies
The following query works as expected (rolls back everything) but I'm surpirsed. Don't I need to in…
6 replies
Hello All, 1) it is some thidparty Db, let's name it as MRMDB 2) Sql server db, let's name it as …
5 replies
Hi We are getting the following error when trying to insert in to a temp table using “Insert into e…
3 replies
Hi, I have 2 similar tables, like these: Create Table Report(Month int, Value float) Create Table R…
1 replies
Hello everyone Here is a table ID date('varchar' type) 1 20100422 2 20100423 3 201004…
7 replies
Viewing 15 topics - 10,006 through 10,020 (of 10,647 total)
You must be logged in to create new topics.