Topics
Started by
Posts
Last post
Based on Andy Warren's article at http://www.sqlservercentral.com/columnists/awarren/copyingdtspack…
4 replies
Guys, I have a table with a single VARCHAR column. The COLLATION for this column is SQL_Latin…
14 replies
query SELECT count(Distinct PolicyNumber),CONVERT(varchar(4), EffectiveDate, 120) from GE_Transact…
3 replies
Can anyone tell me what the problem is with the following code snippet: IF @UserProfileID = '' &nbs…
4 replies
Can anyone suggest a quick way to create 100,000 random numbers without using a cursor or loop ? ie…
26 replies
I have a table with the following structure: MemberNbr varchar(11) StartDate …
6 replies
Hi, I want to run a query on the following table. The Business rule for it is as follo…
3 replies
Hi Would anybody have any T-SQL script that validates UK (and european) VAT numbers to ensure they…
9 replies
Does anyone have good suggestions on third party SQL Editors? I'm using SQL Server 2000 no in…
2 replies
Hi, I need to create an XML partly based on the result of a query, the specs call for a tag that co…
1 replies
select field 1, field2 from table1 where field1 = 'char 200' -- 17 rows select field3, field …
17 replies
I have found a very usefull article on how to export data to a text file using the bcp utility. Unf…
3 replies
Hi everyone, A developer asked me to write a function to split a full name into first, middle, and …
8 replies
Hi there, When I convert an integer to a datevalue in Excel, the returned datevalue differs from th…
10 replies
Hi, I have a question about the performance of database. Overtime, rows are inserted into a table …
1 replies
Viewing 15 topics - 5,491 through 5,505 (of 17,082 total)
You must be logged in to create new topics.