Topics
Started by
Posts
Last post
Hi guys, I have a table with following columns and records. Empid Empname Phone Fl…
3 replies
1) Client_DB on MSSQL has a few views containing client's master data 2) I need to import data from…
6 replies
I need to use a filter on the following code but I cannot use Dynamic SQL: DECLARE @BeginIssueDate …
9 replies
I didn't think this is allowed but i figured I would ask anyway. I have this: declare @str varcha…
4 replies
I have a basic query that is searching a text field (nvarchar(25)) and I noticed when I use LIKE %n…
12 replies
Hello to every one, I have two parameters @param1 = dbname.username.table_name @param2= value Is th…
10 replies
I have a question and I hoping to not sound to lame. I am trying to use the sp_oacreate and the sp…
10 replies
I am running into a issue when trying to get a correct total using SUM. Code: Declare @ConsultantID…
6 replies
char field with over 30,000 rows 6890 of them are null is it possible to make this column unique?
2 replies
hi , I have this query to see all failed jobs but it not works on sql 7.0. it works properly on 200…
1 replies
well I have a table with few records and looks like this START_DT END_DT -----------…
8 replies
A process iterates through a list of keys in a table. For each key it must select records to displa…
4 replies
Hello , use master GO select getdate () as Date,@@servername as servername, name ,size*8/1024 as s…
5 replies
Hi there, I am hoping that someone could offer me some advice on how to requery a resultset. I am a…
2 replies
I ran the following SQL code to create a table in the existing database neuro, into a schema named …
12 replies
Viewing 15 topics - 10,456 through 10,470 (of 12,230 total)
You must be logged in to create new topics.