Topics
Started by
Posts
Last post
Hello, I have the following table and data: table1: ID Col 1&n…
3 replies
Dynamic SQL when used right, as in a parameter to hold the sql, is one of the better ways to code i…
8 replies
Hi, i need help on this.i have a stored procedure as follows which executes a job.i wa…
2 replies
This is my statement in my stored procedure: Select Count (EmployeeStatus) where ..…
4 replies
guys, I have a stored proc - 'NEXTVAL' which gives me value for the column. I pass the tablename as…
3 replies
I have puzzled over this one for a while, and can't seem to get it. I have a table of patients, doc…
6 replies
Hi I need to join two tables having one filed comman but the one field has perfix server na…
1 replies
Guys, I am trying compile below function where I pass tablename as variable. CREATE FUNCTION [dbo].…
3 replies
Hi All Me again... I have a query that extracts data(500 million recs); that is records that has be…
7 replies
I'm trying to find a way to count how many times a string 'xyz' occurs in a ntext column. The colum…
5 replies
Hi All, I have a bat file that works just fine if I execute it manually. However, if I want t…
2 replies
Hi, I have SQL 2000 and am trying to get result set into a table variable in a dynamic SQL statemen…
5 replies
I have a table @CJPercentages that's populated like this in my stored procedure: ID LowerLim…
2 replies
I have a single SQL file that I want to normalise. Fields: CustomerNumber, C…
7 replies
Hello All, I want to create a calculated IsValue bit column in a select statement using CharIn…
9 replies
Viewing 15 topics - 4,786 through 4,800 (of 17,082 total)
You must be logged in to create new topics.