Topics
Started by
Posts
Last post
HI Guys, Quick question about views. If I have a table: MyTable Col1 VARCHAR(10) Null If I then cre…
5 replies
DECLARE @I INT SET @I = 1 WHILE @I < 10000 BEGIN SELECT getdate() SET @I = @I + 1 END Run t…
33 replies
I want to import excel file data to sql server 2000 using sql programming I used following command…
1 replies
I have a Stored Procedure and a table with a date column in it. I am filtering on the date column w…
3 replies
Dimension table with start dates and end dates. End Date is maximum value for the most recent recor…
5 replies
Hi All; I have a table (tblnewsletter) that the date (SendDate) is stored in varchar(50) column. I…
3 replies
Hello all, any assistance with this challenge would be greatly appreciated. I have a field in one o…
1 replies
Hi all....I hope you can answer me this...it is driving me crazy! I have 2 tables. UserGroup/UserG…
2 replies
If I have a simple query like this: SELECT d.[DocumentName] ,d.[DocumentId] ,v.[VersionDescriptio…
12 replies
How can i update multiple columns in table Emp(EmpID,EmpName,EmpTItle,JOd Role,JodId,EMpPay) where …
2 replies
I'm trying to eliminate using a cursor in a stored procedure, but I'm having trouble getting the de…
2 replies
Does anyone know of a way to accumulate values as per the following example: 1. I have data for eac…
16 replies
Alright, Im running SQL Server 2005 Dev Edition on my works laptop. Ive just been reading up on Si…
1 replies
HI all, I looked for an article about this but had no luck. I was wondering if there are any major …
6 replies
Hi, I have a table containing lists of items that can be sorted by a user. This is a sample of the…
8 replies
Viewing 15 topics - 9,946 through 9,960 (of 12,230 total)
You must be logged in to create new topics.