Topics
Started by
Posts
Last post
How to create a row number for a consecutive action. Example: I have a listing of people who have e…
17 replies
I have a query that returns a bunch of rows. I have an sp that takes 3 of the columns in the query …
5 replies
Hello, I'm trying to find the most efficient way of handling failures in a process that looks like …
4 replies
Hello. Could you help me? please. I have a task, download resul set in .csv declare @cmd varchar(8…
8 replies
So, I have a query which uses dynamic-SQL. I noticed some unexpected behavior. I will try to simpli…
1 replies
Hello I execute the code below declare @LastDate datetime SELECT @LastDate = max([LastUpdate]) FR…
7 replies
hi to all, i am facing issue for the following query: for set @FromDate='1/1/2013' set @ToDate='1/1…
1 replies
Hi There, I need to ensure some naming standards to users while creating tables. All table name sho…
5 replies
Guys, Actually I am doing a migration from MySQL to SQL Server. At the moment the database MySQL ha…
6 replies
Hi All, Wondered if someone could possibly help me with a pivot question. I am trying to pivot some…
4 replies
There's an often mentioned "problem" which is sometimes used to help in teaching kids to understand…
10 replies
i have a quick question about internal fragmentation the book explanation is that DML statement cau…
3 replies
Goodnight Would like to separate the dates for months. For example I have a table that shows me the…
1 replies
Hello I use SET @text= CAST (@text AS xml) to convert @text to xml, but it didn't work and I have "…
1 replies
Hi There, I need query that results followings, Table name , Row Count, Size of Table Thanks Many
1 replies
Viewing 15 topics - 4,486 through 4,500 (of 4,984 total)
You must be logged in to create new topics.