Topics
Started by
Posts
Last post
Hi, Is it possible to create a simple CTE within a stored proc and reference the CTE multiple times…
8 replies
hi guys, can anyone tell me the best way to trim spaces after a name in my column productname in my…
24 replies
let's say I have this one, no problem: CREATE PROCEDURE au_info @var text AS DECLARE @hDoc int E…
3 replies
Hi All, I am having 2nos. of Table. 1 st table contains Id | Name ------------ 100 abc…
4 replies
On the forum, all are discouraging the usage of cursor solutions. Does anyone have docs on Set Base…
1 replies
Query 1 select StartTime,Department,JobNumber from Emp1 union all select StartTime,DepartmentDescri…
3 replies
I have been looking at using PIVOT to convert rows to columns but I don't need nor want an aggregat…
2 replies
Hi. I have a query to write that I just cant get my head around the best way to do it in order tha…
4 replies
I have data stored in a SQL 2005 database in the XML data type. I am able to extract values for thi…
1 replies
I didn't want to muddy up someone else's topic, so here's the results of parsing URL data into disc…
6 replies
The top table works, the bottom table it doesn't return any rows. The 3rd is a simplified version o…
9 replies
How would a guy go about selecting data out of a table in this situation. I want to start at the be…
12 replies
If you have to give a flat hike to your employees using the following criteria: Salary between 3000…
6 replies
Hi All, Great forum!!! Here's my problem. I'm trying to build a course schedule of classes for my j…
16 replies
I tried to use DDL statement in procedure. But it show error for using var in alter statement. I wa…
15 replies
Viewing 15 topics - 9,931 through 9,945 (of 12,234 total)
You must be logged in to create new topics.