Topics
Started by
Posts
Last post
Does anyone know how I can delete specific files without using xp_cmdshell? I backup a log file wit…
6 replies
Anyone have or know of a script to get a date based on a number of business days passed in (e.g. to…
1 replies
Hi, We are all aware of dynamic queries. for executing dynamic queries we use EXECUTE / sp_ExecuteS…
1 replies
Was wondering if there was anyone out there that can help me on this one. I have to take a table of…
9 replies
[font="Courier New"]Hi everyone, I've run into a road block using WHERE CONTAINS searching on multi…
6 replies
I have problem calculating Percentage value ? suppose we have two column column_A & Column_B i…
7 replies
I have a t-sql: exec @ret = uspAAA '<?xml version="1.0"? > < SerialNumber><S Descr=…
3 replies
I am having an issue with a server that we are going to be moving to new hardware running SQL 2005 …
2 replies
if normal CASE-WHEN-THEN statement, i can do this, USE pubs GO SELECT 'Price Category' = …
22 replies
How do you export data from a query to an excel file including the column names? :crazy: Thank you!…
2 replies
HI All, What is the difference between xType and Type in sysobjects? Thanks Chris -----------------…
3 replies
Is it possible to run more than one sql statement given a condition ie: if(1 = 1) --insert sta…
2 replies
i need a query that make 'A010' + 1 = 'A011' or 'ABC13456' + 12 = 'ABC13468' how can i do this
10 replies
Hi everyone, I was wondering has anyone competed CURSOR against INNER JOIN for bulk UPDATEs: QUERY …
8 replies
Hello I am running the following 3 seperate queries: USE DB SELECT sum(T_OrderLine.Quantity) AS Sol…
4 replies
Viewing 15 topics - 8,986 through 9,000 (of 12,230 total)
You must be logged in to create new topics.