Topics
Started by
Posts
Last post
I need to capture counts of records in a table by values in columns. For a table that has say 8 dif…
6 replies
I have SS2K but am using SSMS. I am attempting to programmatically capture scripts for all Indexes…
2 replies
Hi Everyone, When I run the dateadd function adding months on 30th and 31st of any months returns …
12 replies
Dear master, I have to compare two table that have same amount (one to one record). my first table …
4 replies
I have write a query make use of dense_rank() to return following table Col1 Col2 Col3 [Dense_Rank…
3 replies
Greetings. I am using OPENROWSET to import an Excel 2003 file into a staging table every day. One…
3 replies
Hello friends, i am having a table with no identity like: CREATE TABLE [dbo].[Demo2]( [id] [int] N…
2 replies
kindly reply any of ...
1 replies
How to add ROW_ID as data below? Since SQL 2000 do not have ROW_NUMBER function. It make it hard fo…
2 replies
I have the following data to be converted. Can someone help me pl? tblA contains CustomerKey NVa…
5 replies
Hello Folks, Am a beginner in Tsql and I have a requirement to write a stored proce…
1 replies
Hi There, I have a table called Currency with below columns: CREATE TABLE [dbo].[Currency]( [Curr…
4 replies
I am executing a job by way of: exec linkedserver.msdb..sp_start_job @job_name = 'JobName' the job …
2 replies
I'm having some problem with using the BULK INSERT command on a fixed width file. The fixed width f…
1 replies
create procedure test_sp as INSERT into employeedetails(ename) values ('@empname') INSERT into empl…
2 replies
Viewing 15 topics - 706 through 720 (of 17,082 total)
You must be logged in to create new topics.