Topics
Started by
Posts
Last post
Is there a single, authoritative source for the display format of telephone numbers worldwide? I a…
5 replies
How do I capture the column names of the updated fields? I can trap the user id, but i cant s…
5 replies
Hi all, Using Microsoft SQL Server, I get this surprising result: select isnumeric('0D830') 1…
7 replies
Ok, I feel stupid here. I have done this before and for some reason just can not think. In fact I b…
4 replies
Need SQL to cast the column "ID" as an INTEGER: SELECT ID, Desc AS 'Domain Name' FROM&nb…
2 replies
Need SQL to accommodate the following data migration for Credit Card numbers: Source column:…
4 replies
Hi, I've the following dynamic SQL stmt. SET @strSQL = N'SET @RSCCount=Select Count(*) From tblRepN…
5 replies
I've got a table (REPORT) with a couple of date columns - DateCreated and DateModified. I set DateC…
3 replies
Hi, I ran this: BULK INSERT XXX.dbo.XXXXX FROM '\\YYYY\WWW\filename.txt' WITH (FIRSTROW = 2) and&n…
2 replies
Hi All, My Actual requirement is to group th…
10 replies
Hey all, is their a way to delete flat files on a local drive through T-SQL? I need to remove all f…
2 replies
Hi Folks, Just wondering if anyone can help me out. I need to identify the number of users who are …
2 replies
I need to know how to use a join which will only take one result from the left hand table of the jo…
15 replies
I am trying to create a conversion script to load a table called POLine. The keys are PLPO an…
2 replies
Assuming I have a table with the just the fields "MemberNo" and "ClaimCount", for example "ABC123" …
5 replies
Viewing 15 topics - 9,781 through 9,795 (of 17,082 total)
You must be logged in to create new topics.