Topics
Started by
Posts
Last post
Hi, so I have a directory of hundreds of text files which I am using bulk insert to bring into SQL.…
4 replies
Hi Guys, I created a wrapper SP that will execute two SPs...Since this will be in SQL 2000, I wante…
6 replies
HI How to write Function that after execute it this result appear (fast algorithm i need) exapmle f…
18 replies
I'm having trouble with dynamic SQL in an OpenRowset command, as per below code snippet. I'm attemp…
4 replies
Hello. Does anyone know of a way to search DTS packages for specific strings? I've come across a …
11 replies
I am reporting on some auditing activity from a sql trace table for the last 7 days. Current quer…
1 replies
There are three sets of dropdowns in my front end 1) SortBy1, SortOrder1 2) SortBy2, SortOrder2 3) …
17 replies
What is the difference between the below queries: select * from table where col IS NOT NULL and sel…
3 replies
I am trying to write a query that will convert; ParentChild AB BC BD Into; ParentChild AC AD…
3 replies
Hi I am hoping for a little guidance with the query below. It returns the number of units made and …
11 replies
Hi, I have a query of the form: DELETE st1 FROM StageTable AS st INNER JOIN Meter m ON m.meter_…
1 replies
The variable @Style='53136E5367-2' and is used in my script as follows: WHERE ITEMMAST.STYLE=@Style…
3 replies
first i cant get this query to insert the records. it shows 'Insert Error: Column name or number o…
6 replies
We are using SQL 2000 I need help with the following situation. I need to pivot some data. I have s…
2 replies
Hi to All, I have a problem and i don't know how to explain this but here is what i want to do. T…
1 replies
Viewing 15 topics - 466 through 480 (of 17,082 total)
You must be logged in to create new topics.