Topics
Started by
Posts
Last post
Hi dude, can u tell me what is CTE( common table expression), how we can use this?. Thank's Sandeep.
5 replies
Hi Team, In our sinario ExchangeTable have 24 columns in this one we have create one clustered inde…
2 replies
I have been working with SQL Server 2005 since 2 years and have always used SQL Server Management S…
14 replies
I have situation where I have nest full name contain format like First Name Initial Last Name First…
8 replies
The following works: SELECT * FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM Company') This does not w…
32 replies
Hello I have a data structure like this: Entities 1 - X EntitieDefinition 1 - X Data I have a query…
3 replies
Hello, If I create some dynamic SQL and execute it using sp_ExecuteSQL, and the SQL I created gener…
3 replies
I was trying to add code to Drop the PK, if it exists and after a Load, I want to Create the PK if …
8 replies
This query was working on SQL 2000 but on SQL 2008 is giving me the error "Divide by zero error enc…
5 replies
Hi all, Can anyone provide a customizable T-SQL script to create millions of rows in a table? My un…
23 replies
Never done recursion in MS SQL. Looked at few samples using CTE, but haven't found what I am lookin…
13 replies
Hi all, I have a table that looks like this. CREATE TABLE #tmp1 (PartID VARCHAR(8), CodeA VARCHAR(…
6 replies
Hi i m newbie for this forum. I have query and it has parameter dates If i change date from 2/1/200…
9 replies
I have 2 tables (suppose A and B) with around 1 million rows each. I want to find and delete the re…
20 replies
Dear all; Table having 1 million record we have to write the quries like this . the number of union…
3 replies
Viewing 15 topics - 6,406 through 6,420 (of 10,635 total)
You must be logged in to create new topics.