Topics
Started by
Posts
Last post
I want to test for the existance of an ASCII text file in a stored procedure. If the file exists I…
3 replies
Good morning everyone, I am writing a stored procedure that accepts as a parameter the name of a ta…
3 replies
I have a field that is type char(9). When I run a package it inserts a 6 digit number into that fi…
3 replies
When joining across multiple tables query result returns more rows than expected. What's wrong!
4 replies
Hi, thanks for you time. Here is my problem. I need to write a stored proc that get info from a s…
1 replies
I have a problem with converting Rows to Column Names. I have created a table (CustomFields) where …
1 replies
I need a T-SQL script that: looks up a Account.Account field and sees whether the first 10 characte…
4 replies
Hi Guys I have got two tables - a) Master Table b) StartDate Table Now this start date table is a…
2 replies
Hello, Insert into #tempTable exec sp_executesql @sql. this statement worked fine till the data wa…
4 replies
Hi All, I feel bad asking this cause I have seen it one this site before and have infact done this …
4 replies
The following statement doesn't use the index on lngbcid. When i have a hardcoded lngbcid in the EL…
1 replies
There is always going to be 1 value in the columns a to e, at all times... Format 1 abcde 12 …
2 replies
I have a table with all our databases in it which is truncated and repopulated daily. I need to pu…
1 replies
Hi all, First time, I have dealt with filtering the duplicated records. Please help me to solve it …
5 replies
Hello, It is rare that I have a user for Triggers, but I have a special case. In a table named tbl_…
4 replies
Viewing 15 topics - 11,341 through 11,355 (of 12,230 total)
You must be logged in to create new topics.