Topics
Started by
Posts
Last post
Greeting extremely helpful SSCers. I've been struggling with trying to noodle through a data transf…
3 replies
I am beginning to doubt my knowledge of sql. seems i can not even write a simple query. select cou…
2 replies
I have a table with the a datetime filed that holds dates. when i run the following query against …
2 replies
I am looking for a more efficient way to select by date (today -1) I am using ...and DATEDIFF(Day, …
10 replies
We are seeing 100% CPU utilization on one of our SQL servers for the process sqlsevr.exe. I ran an …
1 replies
Hi Guys, I have a table named "employeeattendence".The columns are empid,status,empdate.It contain …
2 replies
By: Jared
I need to create a custom backup process that basically replaces the date in the filename with just…
6 replies
By: BigSam
Hi everyone. Noob here. I ran into an odd little problem with a simple update query: UPDATE TABLE S…
6 replies
By: WayneS
I am creating a trigger that is based on a column if update(column)..... The question is can I con…
10 replies
By: mgchris
Hi, i'm new to t-sql and i have a problem now with row by row comparison in sql. I already done thi…
24 replies
So simple question on which is better: storing CSVs in a column vs. table with records. **Doing som…
7 replies
Hi all, Im trying to create an inventory of all our SQL instances. Ive been using SQLCMD -L for on…
4 replies
I was wondering how easy it would be to count occurances across multiple fields? I've a table made …
16 replies
I'm trying to join 2 tables. This is a one-to-many (1-N) join. I have a table with accounts and a…
11 replies
Hi all... I know to capture the deadlock we use trace flags like 1204 1222 and also by using profil…
14 replies
Viewing 15 topics - 3,001 through 3,015 (of 5,050 total)
You must be logged in to create new topics.