Topics
Started by
Posts
Last post
Hi, Every week I want to repopulate a table by doing something along the lines of: TRUNCATE TABL…
3 replies
I have columnA with a single value and columnB with strings in it such as: <ITEM>Jane, Mary&l…
2 replies
I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration t…
7 replies
I have 2 tables, say ,tab1 and tab2 having the same fields-id and modifier that can be related by I…
4 replies
Hello all, I an kind of confused as to how to put my query. Let me try. I have a list of names (Jam…
2 replies
Looking for summary results from two different queries. Getting results: strLocationNameTrunksLin…
11 replies
I have a simple query: SELECT name FROM atable WHERE a = 1 I want it to return Null if it finds n…
7 replies
Hi all, I have two tables one having company data named COMPANY and other have Landmarks data named…
5 replies
I like to get from the JobHistory table the run_date and the run_time and put them in a DateTime fi…
2 replies
I want to pull the "security context" information from linked servers using a query, rather than Pr…
3 replies
Hi, Folks! I fired the following Code from SSMS (SQL2K5 SP2): USE AdventureWorksDW SET STATISTICS …
3 replies
Hello, does anyone know, if it is possible to change the ordinal position of a column? I tried the …
43 replies
I have a table tblUserAccounts. This has the following fields UserId int, UserName varchar(50)…
2 replies
Hi, I'm using SQL queries with LIKE operator to search for keyword(s) in a VARCHAR field of a table…
1 replies
hi i'm creating an audit table using a trigger. is there a way i can retrieve which trigger event f…
5 replies
Viewing 15 topics - 1,636 through 1,650 (of 12,234 total)
You must be logged in to create new topics.