Topics
Started by
Posts
Last post
I have the following to find the failed logins from yesterday from the server logs. sqlcmd -b -d ma…
9 replies
Hi, I have a package with a Execute Process Task object that executes a PowerShell script that down…
5 replies
hi, i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell m…
5 replies
If a table stores in a column of type VARCHAR the textual equivalent of an html page, does SQL Serv…
6 replies
Hi All I would like to get rows wherever it has "restricted" . If I write condition with like '%res…
4 replies
I've used the Import Wizard in SSMS a few times. Mostly to get data from one server to another. Occ…
12 replies
Hi All, Hi All, I want to convert columns result into rows with comma. Ex: Result should be - 'SQL1…
8 replies
Hi All, I am looking for query to get latest full backup with all database except tempDB. I have go…
7 replies
Hello All, Couple of questions on conversion errors. First I have to convert since my reference tab…
6 replies
Looking at the query plan for a rather complicated select, which draws from views, I see the very b…
6 replies
I have some date variables which are used in the SP but one of the main table is going away and I a…
3 replies
Hi I have dataset like this drop table if exists #dataset create table #dataset(CIF VARCHAR(…
4 replies
I know this is easy for someone. We want to create a pivot table from the sample data below. Resul…
5 replies
Hi All, Not sure If I'm over complicating the process but I'm struggling to write or find a solutio…
8 replies
I am trying to select a distinct list of values from multiple tables, combine them into a single ta…
5 replies
Viewing 15 topics - 391 through 405 (of 1,821 total)
You must be logged in to create new topics.