Topics
Started by
Posts
Last post
Hi, I have a table - Table 1 which has the following fields - [Fault] [varchar](20) NULL, [Occurred…
6 replies
xp_cmdshell is enabled I run the following and it says executing but nothing actually happens it ju…
8 replies
I got part of the following idea off a post I saw on Joe Selko's blog... sorry, can't remember the …
3 replies
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
Viewing 15 topics - 9,991 through 10,005 (of 10,635 total)
You must be logged in to create new topics.