Topics
Started by
Posts
Last post
What will be the appropriate datatypes for following Username Machinename Executionstarttime Packag…
9 replies
I have: test.deleteflag ('Y' or 'N') test.deletedate When someone updates test.deleteflag to 'Y', …
10 replies
I have some fairly complex views and want to display the definition of the view columns in some way…
1 replies
I am trying to get distinct counts on forms a certain user has filed for a certain day. I am using …
3 replies
I'm working on a table called "GroupingTest", shown below. myIDmyNamemyMoney 1manny12.00 3moe…
9 replies
I need a simple sql statement with a case to determine whether 2 times need to be added or subtract…
7 replies
Has anyone ever figured out a way to commit a certain number of rows in a select statement. I alw…
4 replies
Greetings, Have just moved to Microsoft SQL Server 2005. Am starting to learn T-SQL. But I have a…
9 replies
I have a script that works in versions. example if @i = 1 BEGIN END if @i = 2 BEGIN END in a block …
4 replies
Hi, When you try this code: DECLARE @a BIGINT SET @a = POWER(2,30) PRINT @a you get: 1073741824 Whe…
4 replies
Hi, Server: Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated. The state…
2 replies
I used to know how to do this, but after 20 years the old grey matter has forgotten. I am doing a m…
4 replies
Hi all, I need to produce some XML from a query, however I'm a little confused. Consider the follow…
5 replies
Good Afternoon Everybody!!!! One of my site have a more than 41,000,00 data. Problem is i want to t…
1 replies
Hi all, How can i get the rank, total rank and percentile in SQL I have no clue!! Please guide!! Th…
5 replies
Viewing 15 topics - 8,041 through 8,055 (of 12,230 total)
You must be logged in to create new topics.